{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='比亚迪')]\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LC0')|(all1['3']=='LGX')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BYD7157A5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BYD7157A5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BYD7157A5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BYD7157A5M2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BYD7157A5M1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BYD7127AT5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1197</td>\n",
       "      <td>82</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BYD7157A5D1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BYD7157A5D2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>BYD7157A5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BYD7127AT5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1197</td>\n",
       "      <td>82</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>BYD7157A5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>BYD7157A5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>BYD7157A5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>BYD7157A5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>BYD7157A5M1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>BYD7157A5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>BYD7157A5D1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>BYD7157A5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>BYD7157A5D2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>BYD7157A5M2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>BYD7157A5M1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>BYD7157A5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>BYD7157A5D1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>BYD7157A5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>BYD7157A5M1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>BYD7157A5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>BYD7157A5D1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>BYD7157A5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>BYD7127AT5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1197</td>\n",
       "      <td>82</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>BYD7127AT5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1197</td>\n",
       "      <td>82</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617x1716x1480</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>800</th>\n",
       "      <td>BYD6460ST8</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1675</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXCG4DF×××××××××,LGXCG4CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>801</th>\n",
       "      <td>BYD6460ST2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1650,1705</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LGXCG4DG×××××××××,LGXCG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>802</th>\n",
       "      <td>BYD6460ST2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1650</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LGXCG4DG×××××××××,LGXCG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803</th>\n",
       "      <td>BYD6460ST6</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1555</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXC14DF×××××××××,LGXC14CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>804</th>\n",
       "      <td>BYD6460ST6</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1555</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXC14DF×××××××××,LGXC14CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>805</th>\n",
       "      <td>BYD6460ST3</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1585</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXCG4DF×××××××××,LGXCG4CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>806</th>\n",
       "      <td>BYD6460ST1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1555</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXC14DF×××××××××,LGXC14CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>807</th>\n",
       "      <td>BYD6460S1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1545</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LGXC14CG×××××××××,LGXC14DG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>808</th>\n",
       "      <td>BYD6460ST4</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1650</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LGXCG4DG×××××××××,LGXCG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809</th>\n",
       "      <td>BYD6460ST2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1650</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LGXCG4DG×××××××××,LGXCG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>810</th>\n",
       "      <td>BYD6460ST3</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1585</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXCG4DF×××××××××,LGXCG4CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>811</th>\n",
       "      <td>BYD6460ST1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1555</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXC14DF×××××××××,LGXC14CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>812</th>\n",
       "      <td>BYD6460S1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1545</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LGXC14CG×××××××××,LGXC14DG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>813</th>\n",
       "      <td>BYD6460ST5</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1650</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4DG×××××××××,LC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>814</th>\n",
       "      <td>BYD6460ST4</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1650</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LGXCG4DG×××××××××,LGXCG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>815</th>\n",
       "      <td>BYD6460ST3</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1585</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXCG4DF×××××××××,LGXCG4CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>816</th>\n",
       "      <td>BYD6460ST1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1555</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXC14DF×××××××××,LGXC14CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>817</th>\n",
       "      <td>BYD6460S1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1545</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565</td>\n",
       "      <td>1830</td>\n",
       "      <td>1720</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LGXC14CG×××××××××,LGXC14DG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "      <td>2660</td>\n",
       "      <td>4565x1830x1720</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>818</th>\n",
       "      <td>BYD6480M5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1765</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0C14DG×××××××××\\nLC0C14CG×××××××××\\nLC0C14AG...</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820x1810x1765</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>819</th>\n",
       "      <td>BYD6480M5F</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1790</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4DG×××××××××\\nLC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820x1810x1765</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>820</th>\n",
       "      <td>BYD6480M5A</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1790</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0C14DG×××××××××\\nLC0C14CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820x1810x1765</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>821</th>\n",
       "      <td>BYD6480M5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1765</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0C14DG×××××××××,LC0C14CG×××××××××,LC0C14AG××...</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820x1810x1765</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>822</th>\n",
       "      <td>BYD6480M5F</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1790</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4DG×××××××××,LC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820x1810x1765</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>823</th>\n",
       "      <td>BYD6480M5A</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1790</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0C14DG×××××××××,LC0C14CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820x1810x1765</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>BYD6480M5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1765</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0C14DG×××××××××,LC0C14CG×××××××××,LC0C14AG××...</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820x1810x1765</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>825</th>\n",
       "      <td>BYD6480M5A</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1790</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0C14DG×××××××××,LC0C14CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820x1810x1765</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>826</th>\n",
       "      <td>BYD6480M5F</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1790</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4DG×××××××××,LC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820x1810x1765</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>827</th>\n",
       "      <td>BYD6480M5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1765</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0CG4DG×××××××××,LC0CG4CG×××××××××,LC0CG4AG××...</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820x1810x1765</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>828</th>\n",
       "      <td>BYD6480M5F</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1790</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4DG×××××××××,LC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820x1810x1765</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>829</th>\n",
       "      <td>BYD6480M5A</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1790</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4DG×××××××××,LC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820x1810x1765</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>830 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     notice_type brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0     BYD7157A5M     比亚迪        1210      2615       4617      1716   \n",
       "1     BYD7157A5D     比亚迪        1210      2615       4617      1716   \n",
       "2     BYD7157A5M     比亚迪        1210      2615       4617      1716   \n",
       "3    BYD7157A5M2     比亚迪        1210      2615       4617      1716   \n",
       "4    BYD7157A5M1     比亚迪        1210      2615       4617      1716   \n",
       "5    BYD7127AT5D     比亚迪        1210      2615       4617      1716   \n",
       "6    BYD7157A5D1     比亚迪        1210      2615       4617      1716   \n",
       "7    BYD7157A5D2     比亚迪        1210      2615       4617      1716   \n",
       "8     BYD7157A5D     比亚迪        1210      2615       4617      1716   \n",
       "9    BYD7127AT5M     比亚迪        1210      2615       4617      1716   \n",
       "10    BYD7157A5M     比亚迪        1210      2615       4617      1716   \n",
       "11    BYD7157A5D     比亚迪        1210      2615       4617      1716   \n",
       "12    BYD7157A5D     比亚迪        1210      2615       4617      1716   \n",
       "13    BYD7157A5M     比亚迪        1210      2615       4617      1716   \n",
       "14   BYD7157A5M1     比亚迪        1210      2615       4617      1716   \n",
       "15    BYD7157A5D     比亚迪        1210      2615       4617      1716   \n",
       "16   BYD7157A5D1     比亚迪        1210      2615       4617      1716   \n",
       "17    BYD7157A5M     比亚迪        1210      2615       4617      1716   \n",
       "18   BYD7157A5D2     比亚迪        1210      2615       4617      1716   \n",
       "19   BYD7157A5M2     比亚迪        1210      2615       4617      1716   \n",
       "20   BYD7157A5M1     比亚迪        1210      2615       4617      1716   \n",
       "21    BYD7157A5D     比亚迪        1210      2615       4617      1716   \n",
       "22   BYD7157A5D1     比亚迪        1210      2615       4617      1716   \n",
       "23    BYD7157A5M     比亚迪        1210      2615       4617      1716   \n",
       "24   BYD7157A5M1     比亚迪        1210      2615       4617      1716   \n",
       "25    BYD7157A5D     比亚迪        1210      2615       4617      1716   \n",
       "26   BYD7157A5D1     比亚迪        1210      2615       4617      1716   \n",
       "27    BYD7157A5M     比亚迪        1210      2615       4617      1716   \n",
       "28   BYD7127AT5D     比亚迪        1210      2615       4617      1716   \n",
       "29   BYD7127AT5M     比亚迪        1210      2615       4617      1716   \n",
       "..           ...     ...         ...       ...        ...       ...   \n",
       "800   BYD6460ST8     比亚迪        1675      2660       4565      1830   \n",
       "801   BYD6460ST2     比亚迪   1650,1705      2660       4565      1830   \n",
       "802   BYD6460ST2     比亚迪        1650      2660       4565      1830   \n",
       "803   BYD6460ST6     比亚迪        1555      2660       4565      1830   \n",
       "804   BYD6460ST6     比亚迪        1555      2660       4565      1830   \n",
       "805   BYD6460ST3     比亚迪        1585      2660       4565      1830   \n",
       "806   BYD6460ST1     比亚迪        1555      2660       4565      1830   \n",
       "807    BYD6460S1     比亚迪        1545      2660       4565      1830   \n",
       "808   BYD6460ST4     比亚迪        1650      2660       4565      1830   \n",
       "809   BYD6460ST2     比亚迪        1650      2660       4565      1830   \n",
       "810   BYD6460ST3     比亚迪        1585      2660       4565      1830   \n",
       "811   BYD6460ST1     比亚迪        1555      2660       4565      1830   \n",
       "812    BYD6460S1     比亚迪        1545      2660       4565      1830   \n",
       "813   BYD6460ST5     比亚迪        1650      2660       4565      1830   \n",
       "814   BYD6460ST4     比亚迪        1650      2660       4565      1830   \n",
       "815   BYD6460ST3     比亚迪        1585      2660       4565      1830   \n",
       "816   BYD6460ST1     比亚迪        1555      2660       4565      1830   \n",
       "817    BYD6460S1     比亚迪        1545      2660       4565      1830   \n",
       "818   BYD6480M5M     比亚迪        1765      2960       4820      1810   \n",
       "819   BYD6480M5F     比亚迪        1790      2960       4820      1810   \n",
       "820   BYD6480M5A     比亚迪        1790      2960       4820      1810   \n",
       "821   BYD6480M5M     比亚迪        1765      2960       4820      1810   \n",
       "822   BYD6480M5F     比亚迪        1790      2960       4820      1810   \n",
       "823   BYD6480M5A     比亚迪        1790      2960       4820      1810   \n",
       "824   BYD6480M5M     比亚迪        1765      2960       4820      1810   \n",
       "825   BYD6480M5A     比亚迪        1790      2960       4820      1810   \n",
       "826   BYD6480M5F     比亚迪        1790      2960       4820      1810   \n",
       "827   BYD6480M5M     比亚迪        1765      2960       4820      1810   \n",
       "828   BYD6480M5F     比亚迪        1790      2960       4820      1810   \n",
       "829   BYD6480M5A     比亚迪        1790      2960       4820      1810   \n",
       "\n",
       "    car_height Displacement power  \\\n",
       "0         1480         1497    80   \n",
       "1         1480         1497    80   \n",
       "2         1480         1497    80   \n",
       "3         1480         1497    80   \n",
       "4         1480         1497    80   \n",
       "5         1480         1197    82   \n",
       "6         1480         1497    80   \n",
       "7         1480         1497    80   \n",
       "8         1480         1497    80   \n",
       "9         1480         1197    82   \n",
       "10        1480         1497    80   \n",
       "11        1480         1497    80   \n",
       "12        1480         1497    80   \n",
       "13        1480         1497    80   \n",
       "14        1480         1497    80   \n",
       "15        1480         1497    80   \n",
       "16        1480         1497    80   \n",
       "17        1480         1497    80   \n",
       "18        1480         1497    80   \n",
       "19        1480         1497    80   \n",
       "20        1480         1497    80   \n",
       "21        1480         1497    80   \n",
       "22        1480         1497    80   \n",
       "23        1480         1497    80   \n",
       "24        1480         1497    80   \n",
       "25        1480         1497    80   \n",
       "26        1480         1497    80   \n",
       "27        1480         1497    80   \n",
       "28        1480         1197    82   \n",
       "29        1480         1197    82   \n",
       "..         ...          ...   ...   \n",
       "800       1720         1497   113   \n",
       "801       1720         1999   151   \n",
       "802       1720         1999   151   \n",
       "803       1720         1497   113   \n",
       "804       1720         1497   113   \n",
       "805       1720         1497   113   \n",
       "806       1720         1497   113   \n",
       "807       1720         1991   103   \n",
       "808       1720         1999   151   \n",
       "809       1720         1999   151   \n",
       "810       1720         1497   113   \n",
       "811       1720         1497   113   \n",
       "812       1720         1991   103   \n",
       "813       1720         1999   151   \n",
       "814       1720         1999   151   \n",
       "815       1720         1497   113   \n",
       "816       1720         1497   113   \n",
       "817       1720         1991   103   \n",
       "818       1765         1991   103   \n",
       "819       1765         2362   123   \n",
       "820       1765         2362   123   \n",
       "821       1765         1991   103   \n",
       "822       1765         2362   123   \n",
       "823       1765         2362   123   \n",
       "824       1765         1991   103   \n",
       "825       1765         2362   123   \n",
       "826       1765         2362   123   \n",
       "827       1765         1991   103   \n",
       "828       1765         2362   123   \n",
       "829       1765         2362   123   \n",
       "\n",
       "                                                   vin  car_factory    3  \\\n",
       "0    LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "1    LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "2    LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "3    LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "4    LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "5    LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "6    LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "7    LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "8    LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "9    LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "10   LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "11   LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "12   LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "13   LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "14   LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "15   LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "16   LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "17   LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "18   LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "19   LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "20   LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "21   LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "22   LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "23   LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "24   LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "25   LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "26   LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "27   LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "28   LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...    比亚迪汽车有限公司  LGX   \n",
       "29   LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...    比亚迪汽车有限公司  LGX   \n",
       "..                                                 ...          ...  ...   \n",
       "800                LGXCG4DF×××××××××,LGXCG4CF×××××××××    比亚迪汽车有限公司  LGX   \n",
       "801                LGXCG4DG×××××××××,LGXCG4CG×××××××××    比亚迪汽车有限公司  LGX   \n",
       "802                LGXCG4DG×××××××××,LGXCG4CG×××××××××    比亚迪汽车有限公司  LGX   \n",
       "803                LGXC14DF×××××××××,LGXC14CF×××××××××    比亚迪汽车有限公司  LGX   \n",
       "804                LGXC14DF×××××××××,LGXC14CF×××××××××    比亚迪汽车有限公司  LGX   \n",
       "805                LGXCG4DF×××××××××,LGXCG4CF×××××××××    比亚迪汽车有限公司  LGX   \n",
       "806                LGXC14DF×××××××××,LGXC14CF×××××××××    比亚迪汽车有限公司  LGX   \n",
       "807                LGXC14CG×××××××××,LGXC14DG×××××××××    比亚迪汽车有限公司  LGX   \n",
       "808                LGXCG4DG×××××××××,LGXCG4CG×××××××××    比亚迪汽车有限公司  LGX   \n",
       "809                LGXCG4DG×××××××××,LGXCG4CG×××××××××    比亚迪汽车有限公司  LGX   \n",
       "810                LGXCG4DF×××××××××,LGXCG4CF×××××××××    比亚迪汽车有限公司  LGX   \n",
       "811                LGXC14DF×××××××××,LGXC14CF×××××××××    比亚迪汽车有限公司  LGX   \n",
       "812                LGXC14CG×××××××××,LGXC14DG×××××××××    比亚迪汽车有限公司  LGX   \n",
       "813                LC0CG4DG×××××××××,LC0CG4CG×××××××××  比亚迪汽车工业有限公司  LC0   \n",
       "814                LGXCG4DG×××××××××,LGXCG4CG×××××××××    比亚迪汽车有限公司  LGX   \n",
       "815                LGXCG4DF×××××××××,LGXCG4CF×××××××××    比亚迪汽车有限公司  LGX   \n",
       "816                LGXC14DF×××××××××,LGXC14CF×××××××××    比亚迪汽车有限公司  LGX   \n",
       "817                LGXC14CG×××××××××,LGXC14DG×××××××××    比亚迪汽车有限公司  LGX   \n",
       "818  LC0C14DG×××××××××\\nLC0C14CG×××××××××\\nLC0C14AG...  比亚迪汽车工业有限公司  LC0   \n",
       "819               LC0CG4DG×××××××××\\nLC0CG4CG×××××××××  比亚迪汽车工业有限公司  LC0   \n",
       "820               LC0C14DG×××××××××\\nLC0C14CG×××××××××  比亚迪汽车工业有限公司  LC0   \n",
       "821  LC0C14DG×××××××××,LC0C14CG×××××××××,LC0C14AG××...  比亚迪汽车工业有限公司  LC0   \n",
       "822                LC0CG4DG×××××××××,LC0CG4CG×××××××××  比亚迪汽车工业有限公司  LC0   \n",
       "823                LC0C14DG×××××××××,LC0C14CG×××××××××  比亚迪汽车工业有限公司  LC0   \n",
       "824  LC0C14DG×××××××××,LC0C14CG×××××××××,LC0C14AG××...  比亚迪汽车工业有限公司  LC0   \n",
       "825                LC0C14DG×××××××××,LC0C14CG×××××××××  比亚迪汽车工业有限公司  LC0   \n",
       "826                LC0CG4DG×××××××××,LC0CG4CG×××××××××  比亚迪汽车工业有限公司  LC0   \n",
       "827  LC0CG4DG×××××××××,LC0CG4CG×××××××××,LC0CG4AG××...  比亚迪汽车工业有限公司  LC0   \n",
       "828                LC0CG4DG×××××××××,LC0CG4CG×××××××××  比亚迪汽车工业有限公司  LC0   \n",
       "829                LC0CG4DG×××××××××,LC0CG4CG×××××××××  比亚迪汽车工业有限公司  LC0   \n",
       "\n",
       "    轴距[mm]       长×宽×高[mm] brand_y  style  factory  \n",
       "0     2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "1     2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "2     2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "3     2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "4     2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "5     2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "6     2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "7     2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "8     2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "9     2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "10    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "11    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "12    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "13    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "14    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "15    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "16    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "17    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "18    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "19    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "20    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "21    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "22    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "23    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "24    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "25    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "26    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "27    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "28    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "29    2615  4617x1716x1480     比亚迪  比亚迪F3        7  \n",
       "..     ...             ...     ...    ...      ...  \n",
       "800   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "801   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "802   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "803   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "804   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "805   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "806   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "807   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "808   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "809   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "810   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "811   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "812   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "813   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "814   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "815   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "816   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "817   2660  4565x1830x1720     比亚迪      宋       31  \n",
       "818   2960  4820x1810x1765     比亚迪  比亚迪M6       10  \n",
       "819   2960  4820x1810x1765     比亚迪  比亚迪M6       10  \n",
       "820   2960  4820x1810x1765     比亚迪  比亚迪M6       10  \n",
       "821   2960  4820x1810x1765     比亚迪  比亚迪M6       10  \n",
       "822   2960  4820x1810x1765     比亚迪  比亚迪M6       10  \n",
       "823   2960  4820x1810x1765     比亚迪  比亚迪M6       10  \n",
       "824   2960  4820x1810x1765     比亚迪  比亚迪M6       10  \n",
       "825   2960  4820x1810x1765     比亚迪  比亚迪M6       10  \n",
       "826   2960  4820x1810x1765     比亚迪  比亚迪M6       10  \n",
       "827   2960  4820x1810x1765     比亚迪  比亚迪M6       10  \n",
       "828   2960  4820x1810x1765     比亚迪  比亚迪M6       10  \n",
       "829   2960  4820x1810x1765     比亚迪  比亚迪M6       10  \n",
       "\n",
       "[830 rows x 17 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('比亚迪_VIN.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [notice_type, brand, curb_weight, Wheelbase, car_length, car_width, car_height, Displacement, power, vin, car_factory, 3]\n",
       "Index: []"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all1[(all1['3']=='LCO')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>brand</th>\n",
       "      <th>style</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LGXC16DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>LGXC16AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>LGXCG6DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>LGXCG6AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>LGXCG6CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>LGXC16DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪e5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪e5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>LGXC16DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>速锐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>速锐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>LGXCG6DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪e5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>LGXCG6CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪e5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>LGXCG6DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>速锐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>LGXCG6CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>速锐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>LGXCG6DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪G5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>LGXCG6CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪G5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>LGXC16DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪G5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪G5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>674</th>\n",
       "      <td>LGXC36DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>675</th>\n",
       "      <td>LGXC36AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771</th>\n",
       "      <td>LGXC96DG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772</th>\n",
       "      <td>LGXC96AG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>773</th>\n",
       "      <td>LGXC16DG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>774</th>\n",
       "      <td>LGXC16AG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>838</th>\n",
       "      <td>LGXC26DG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪F3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>844</th>\n",
       "      <td>LGXC16DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪L3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>845</th>\n",
       "      <td>LGXC16AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪L3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>846</th>\n",
       "      <td>LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪L3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>847</th>\n",
       "      <td>LGXCG6DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪L3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>848</th>\n",
       "      <td>LGXCG6AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪L3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1669</th>\n",
       "      <td>LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋MAX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1672</th>\n",
       "      <td>LC0C14DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋MAX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1681</th>\n",
       "      <td>LC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪S7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1682</th>\n",
       "      <td>LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪S7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1683</th>\n",
       "      <td>LC0C14DF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪S7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1684</th>\n",
       "      <td>LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪S7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1695</th>\n",
       "      <td>LC0C64CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪S7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1696</th>\n",
       "      <td>LC0C64DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪S7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1703</th>\n",
       "      <td>LC0C14DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪S7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1704</th>\n",
       "      <td>LC0C14CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪S7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1763</th>\n",
       "      <td>LC0CG4DF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>元</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1764</th>\n",
       "      <td>LC0CG4CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>元</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1767</th>\n",
       "      <td>LC0C14DF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>元</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1768</th>\n",
       "      <td>LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>元</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1819</th>\n",
       "      <td>LGXCG4DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1820</th>\n",
       "      <td>LGXCG4CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1821</th>\n",
       "      <td>LGXCG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1822</th>\n",
       "      <td>LGXCG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1825</th>\n",
       "      <td>LGXC14DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1826</th>\n",
       "      <td>LGXC14CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1833</th>\n",
       "      <td>LGXC14CG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1834</th>\n",
       "      <td>LGXC14DG×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1845</th>\n",
       "      <td>LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1846</th>\n",
       "      <td>LC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>宋</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1855</th>\n",
       "      <td>LC0C14DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1856</th>\n",
       "      <td>LC0C14CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1857</th>\n",
       "      <td>LC0C14AG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1858</th>\n",
       "      <td>LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1859</th>\n",
       "      <td>LC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1878</th>\n",
       "      <td>LC0CG4AG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>比亚迪M6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>184 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    vin  car_factory brand  style\n",
       "0     LGXC16DF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪F3\n",
       "1     LGXC16AF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪F3\n",
       "2     LGXC16CF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪F3\n",
       "3     LGXCG6DF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪F3\n",
       "4     LGXCG6AF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪F3\n",
       "5     LGXCG6CF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪F3\n",
       "102   LGXC16DF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪e5\n",
       "103   LGXC16CF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪e5\n",
       "104   LGXC16DF×××××××××    比亚迪汽车有限公司   比亚迪     速锐\n",
       "105   LGXC16CF×××××××××    比亚迪汽车有限公司   比亚迪     速锐\n",
       "110   LGXCG6DF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪e5\n",
       "111   LGXCG6CF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪e5\n",
       "112   LGXCG6DF×××××××××    比亚迪汽车有限公司   比亚迪     速锐\n",
       "113   LGXCG6CF×××××××××    比亚迪汽车有限公司   比亚迪     速锐\n",
       "422   LGXCG6DF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪G5\n",
       "423   LGXCG6CF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪G5\n",
       "428   LGXC16DF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪G5\n",
       "429   LGXC16CF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪G5\n",
       "674   LGXC36DF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪F3\n",
       "675   LGXC36AF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪F3\n",
       "771   LGXC96DG×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪F3\n",
       "772   LGXC96AG×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪F3\n",
       "773   LGXC16DG×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪F3\n",
       "774   LGXC16AG×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪F3\n",
       "838   LGXC26DG×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪F3\n",
       "844   LGXC16DF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪L3\n",
       "845   LGXC16AF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪L3\n",
       "846   LGXC16CF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪L3\n",
       "847   LGXCG6DF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪L3\n",
       "848   LGXCG6AF×××××××××    比亚迪汽车有限公司   比亚迪  比亚迪L3\n",
       "...                 ...          ...   ...    ...\n",
       "1669  LC0C14CF×××××××××  比亚迪汽车工业有限公司   比亚迪   宋MAX\n",
       "1672  LC0C14DG×××××××××  比亚迪汽车工业有限公司   比亚迪   宋MAX\n",
       "1681  LC0CG4CG×××××××××  比亚迪汽车工业有限公司   比亚迪  比亚迪S7\n",
       "1682  LC0CG4DG×××××××××  比亚迪汽车工业有限公司   比亚迪  比亚迪S7\n",
       "1683  LC0C14DF×××××××××  比亚迪汽车工业有限公司   比亚迪  比亚迪S7\n",
       "1684  LC0C14CF×××××××××  比亚迪汽车工业有限公司   比亚迪  比亚迪S7\n",
       "1695  LC0C64CG×××××××××  比亚迪汽车工业有限公司   比亚迪  比亚迪S7\n",
       "1696  LC0C64DG×××××××××  比亚迪汽车工业有限公司   比亚迪  比亚迪S7\n",
       "1703  LC0C14DG×××××××××  比亚迪汽车工业有限公司   比亚迪  比亚迪S7\n",
       "1704  LC0C14CG×××××××××  比亚迪汽车工业有限公司   比亚迪  比亚迪S7\n",
       "1763  LC0CG4DF×××××××××  比亚迪汽车工业有限公司   比亚迪      元\n",
       "1764  LC0CG4CF×××××××××  比亚迪汽车工业有限公司   比亚迪      元\n",
       "1767  LC0C14DF×××××××××  比亚迪汽车工业有限公司   比亚迪      元\n",
       "1768  LC0C14CF×××××××××  比亚迪汽车工业有限公司   比亚迪      元\n",
       "1819  LGXCG4DF×××××××××    比亚迪汽车有限公司   比亚迪      宋\n",
       "1820  LGXCG4CF×××××××××    比亚迪汽车有限公司   比亚迪      宋\n",
       "1821  LGXCG4DG×××××××××    比亚迪汽车有限公司   比亚迪      宋\n",
       "1822  LGXCG4CG×××××××××    比亚迪汽车有限公司   比亚迪      宋\n",
       "1825  LGXC14DF×××××××××    比亚迪汽车有限公司   比亚迪      宋\n",
       "1826  LGXC14CF×××××××××    比亚迪汽车有限公司   比亚迪      宋\n",
       "1833  LGXC14CG×××××××××    比亚迪汽车有限公司   比亚迪      宋\n",
       "1834  LGXC14DG×××××××××    比亚迪汽车有限公司   比亚迪      宋\n",
       "1845  LC0CG4DG×××××××××  比亚迪汽车工业有限公司   比亚迪      宋\n",
       "1846  LC0CG4CG×××××××××  比亚迪汽车工业有限公司   比亚迪      宋\n",
       "1855  LC0C14DG×××××××××  比亚迪汽车工业有限公司   比亚迪  比亚迪M6\n",
       "1856  LC0C14CG×××××××××  比亚迪汽车工业有限公司   比亚迪  比亚迪M6\n",
       "1857  LC0C14AG×××××××××  比亚迪汽车工业有限公司   比亚迪  比亚迪M6\n",
       "1858  LC0CG4DG×××××××××  比亚迪汽车工业有限公司   比亚迪  比亚迪M6\n",
       "1859  LC0CG4CG×××××××××  比亚迪汽车工业有限公司   比亚迪  比亚迪M6\n",
       "1878  LC0CG4AG×××××××××  比亚迪汽车工业有限公司   比亚迪  比亚迪M6\n",
       "\n",
       "[184 rows x 4 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>BYD7157A5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>BYD7157A5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>BYD7150S5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1325</td>\n",
       "      <td>2535</td>\n",
       "      <td>4360,4100</td>\n",
       "      <td>1785</td>\n",
       "      <td>1650</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>BYD7150ST5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1430</td>\n",
       "      <td>2535</td>\n",
       "      <td>4360,4100</td>\n",
       "      <td>1785</td>\n",
       "      <td>1650</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0CG4DF×××××××××,LC0CG4CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>BYD7152W</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1270</td>\n",
       "      <td>2718</td>\n",
       "      <td>4765</td>\n",
       "      <td>1837</td>\n",
       "      <td>1500</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>BYD7150S5M1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1325</td>\n",
       "      <td>2535</td>\n",
       "      <td>4360,4100</td>\n",
       "      <td>1785</td>\n",
       "      <td>1650</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>BYD7152WT1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1335</td>\n",
       "      <td>2718</td>\n",
       "      <td>4765</td>\n",
       "      <td>1837</td>\n",
       "      <td>1500</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>BYD7152WT2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1380</td>\n",
       "      <td>2718</td>\n",
       "      <td>4765</td>\n",
       "      <td>1837</td>\n",
       "      <td>1500</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXC36DF×××××××××,LGXC36CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>BYD7150S5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1345</td>\n",
       "      <td>2535</td>\n",
       "      <td>4360,4100</td>\n",
       "      <td>1785</td>\n",
       "      <td>1650</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LC0CG4DF×××××××××,LC0CG4CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td>BYD7150W5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1330</td>\n",
       "      <td>2660</td>\n",
       "      <td>4680</td>\n",
       "      <td>1765</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>BYD7150W5M1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1330</td>\n",
       "      <td>2660</td>\n",
       "      <td>4680</td>\n",
       "      <td>1765</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696</th>\n",
       "      <td>BYD7151WT4</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1395</td>\n",
       "      <td>2670</td>\n",
       "      <td>4700</td>\n",
       "      <td>1790</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>698</th>\n",
       "      <td>BYD7150W9</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1370</td>\n",
       "      <td>2660</td>\n",
       "      <td>4680</td>\n",
       "      <td>1765</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699</th>\n",
       "      <td>BYD7151W3</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1370</td>\n",
       "      <td>2670</td>\n",
       "      <td>4700</td>\n",
       "      <td>1790</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td>BYD7156A5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4605</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>701</th>\n",
       "      <td>QCJ7150A11</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4533</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>702</th>\n",
       "      <td>BYD7150W8</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1330</td>\n",
       "      <td>2660</td>\n",
       "      <td>4680</td>\n",
       "      <td>1765</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>703</th>\n",
       "      <td>BYD7157A5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>704</th>\n",
       "      <td>BYD7157A5M2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>705</th>\n",
       "      <td>BYD7151W5D1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1370</td>\n",
       "      <td>2670</td>\n",
       "      <td>4700</td>\n",
       "      <td>1790</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>BYD7157A5M1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>721</th>\n",
       "      <td>BYD7153A5M1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4568</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>722</th>\n",
       "      <td>BYD7150A5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4533</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>724</th>\n",
       "      <td>BYD7156A5D2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4605</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>725</th>\n",
       "      <td>BYD7156A2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4605</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>726</th>\n",
       "      <td>BYD7151W5M1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1330</td>\n",
       "      <td>2670</td>\n",
       "      <td>4700</td>\n",
       "      <td>1790</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>735</th>\n",
       "      <td>BYD7156A1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4605</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>737</th>\n",
       "      <td>BYD7150A5D1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4533</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>740</th>\n",
       "      <td>BYD7150WT5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1385</td>\n",
       "      <td>2660</td>\n",
       "      <td>4680</td>\n",
       "      <td>1765</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>747</th>\n",
       "      <td>BYD7156A5M2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4605</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6922</th>\n",
       "      <td>BYD6481ST2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1610,1630</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6930</th>\n",
       "      <td>BYD6450V2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1400</td>\n",
       "      <td>2725</td>\n",
       "      <td>4460</td>\n",
       "      <td>1720</td>\n",
       "      <td>1850</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0C14DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6936</th>\n",
       "      <td>BYD6450V3</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1400</td>\n",
       "      <td>2725</td>\n",
       "      <td>4460</td>\n",
       "      <td>1720</td>\n",
       "      <td>1850</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0C14DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6938</th>\n",
       "      <td>BYD6481ST8</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730,1750</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6955</th>\n",
       "      <td>BYD6481ST6</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730,1750</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6964</th>\n",
       "      <td>BYD6480M5F</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1790</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4DG×××××××××,LC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6993</th>\n",
       "      <td>BYD6481ST6D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730,1750</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6994</th>\n",
       "      <td>BYD6481S9D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1695,1715</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7199</th>\n",
       "      <td>BYD6480S5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1620,1640</td>\n",
       "      <td>2720</td>\n",
       "      <td>4810</td>\n",
       "      <td>1855</td>\n",
       "      <td>1725,1680</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0C14AG×××××××××,LC0C14DG×××××××××,LC0C14CG××...</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7200</th>\n",
       "      <td>BYD6480M5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1765</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0CG4DG×××××××××,LC0CG4CG×××××××××,LC0CG4AG××...</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7213</th>\n",
       "      <td>BYD6480ST2M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1610,1630</td>\n",
       "      <td>2720</td>\n",
       "      <td>4810</td>\n",
       "      <td>1855</td>\n",
       "      <td>1725,1680</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0C14AF×××××××××,LC0C14DF×××××××××,LC0C14CF××...</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7214</th>\n",
       "      <td>BYD6480M5F</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1790</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4DG×××××××××,LC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7222</th>\n",
       "      <td>BYD6481ST3M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1610,1630</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7223</th>\n",
       "      <td>BYD6480S6M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1665,1685</td>\n",
       "      <td>2720</td>\n",
       "      <td>4810</td>\n",
       "      <td>1855</td>\n",
       "      <td>1725,1680</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0C14AG×××××××××,LC0C14DG×××××××××,LC0C14CG××...</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7247</th>\n",
       "      <td>BYD6480M5A</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1790</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4DG×××××××××,LC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7297</th>\n",
       "      <td>BYD6480S2D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1695,1715</td>\n",
       "      <td>2720</td>\n",
       "      <td>4810</td>\n",
       "      <td>1855</td>\n",
       "      <td>1725,1680</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4AG×××××××××,LC0CG4CG×××××××××,LC0CG4DG××...</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7510</th>\n",
       "      <td>BYD6481ST</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7511</th>\n",
       "      <td>BYD6481ST8</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730,1750</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7614</th>\n",
       "      <td>BYD6481ST6</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730,1750</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7807</th>\n",
       "      <td>BYD6481ST5</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1810,1830</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0C64CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7856</th>\n",
       "      <td>BYD6481ST3</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1610,1630</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8072</th>\n",
       "      <td>BYD6481ST</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8076</th>\n",
       "      <td>BYD6450V3</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1400</td>\n",
       "      <td>2725</td>\n",
       "      <td>4460</td>\n",
       "      <td>1720</td>\n",
       "      <td>1850</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0C14DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8113</th>\n",
       "      <td>BYD6481ST2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1610,1630</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8134</th>\n",
       "      <td>BYD6481ST8</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730,1750</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8201</th>\n",
       "      <td>BYD6450V2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1400</td>\n",
       "      <td>2725</td>\n",
       "      <td>4460</td>\n",
       "      <td>1720</td>\n",
       "      <td>1850</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0C14DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8219</th>\n",
       "      <td>BYD6481ST5</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1810,1830</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0C64CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8260</th>\n",
       "      <td>BYD6450V1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1300</td>\n",
       "      <td>2725</td>\n",
       "      <td>4460</td>\n",
       "      <td>1720</td>\n",
       "      <td>1850</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14AF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8690</th>\n",
       "      <td>BYD6481ST3</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1610</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8708</th>\n",
       "      <td>BYD6481ST2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1610</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>843 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      notice_type brand curb_weight Wheelbase car_length car_width car_height  \\\n",
       "25     BYD7157A5M   比亚迪        1210      2615       4617      1716       1480   \n",
       "54     BYD7157A5D   比亚迪        1210      2615       4617      1716       1480   \n",
       "88     BYD7150S5M   比亚迪        1325      2535  4360,4100      1785       1650   \n",
       "90    BYD7150ST5D   比亚迪        1430      2535  4360,4100      1785       1650   \n",
       "106      BYD7152W   比亚迪        1270      2718       4765      1837       1500   \n",
       "137   BYD7150S5M1   比亚迪        1325      2535  4360,4100      1785       1650   \n",
       "139    BYD7152WT1   比亚迪        1335      2718       4765      1837       1500   \n",
       "145    BYD7152WT2   比亚迪        1380      2718       4765      1837       1500   \n",
       "155    BYD7150S5D   比亚迪        1345      2535  4360,4100      1785       1650   \n",
       "594    BYD7150W5M   比亚迪        1330      2660       4680      1765       1490   \n",
       "688   BYD7150W5M1   比亚迪        1330      2660       4680      1765       1490   \n",
       "696    BYD7151WT4   比亚迪        1395      2670       4700      1790       1480   \n",
       "698     BYD7150W9   比亚迪        1370      2660       4680      1765       1490   \n",
       "699     BYD7151W3   比亚迪        1370      2670       4700      1790       1480   \n",
       "700    BYD7156A5D   比亚迪        1210      2600       4605      1705       1490   \n",
       "701    QCJ7150A11   比亚迪        1210      2600       4533      1705       1490   \n",
       "702     BYD7150W8   比亚迪        1330      2660       4680      1765       1490   \n",
       "703    BYD7157A5M   比亚迪        1210      2615       4617      1716       1480   \n",
       "704   BYD7157A5M2   比亚迪        1210      2615       4617      1716       1480   \n",
       "705   BYD7151W5D1   比亚迪        1370      2670       4700      1790       1480   \n",
       "720   BYD7157A5M1   比亚迪        1210      2615       4617      1716       1480   \n",
       "721   BYD7153A5M1   比亚迪        1210      2615       4568      1716       1480   \n",
       "722    BYD7150A5M   比亚迪        1210      2600       4533      1705       1490   \n",
       "724   BYD7156A5D2   比亚迪        1210      2600       4605      1705       1490   \n",
       "725     BYD7156A2   比亚迪        1210      2600       4605      1705       1490   \n",
       "726   BYD7151W5M1   比亚迪        1330      2670       4700      1790       1480   \n",
       "735     BYD7156A1   比亚迪        1210      2600       4605      1705       1490   \n",
       "737   BYD7150A5D1   比亚迪        1210      2600       4533      1705       1490   \n",
       "740   BYD7150WT5M   比亚迪        1385      2660       4680      1765       1490   \n",
       "747   BYD7156A5M2   比亚迪        1210      2600       4605      1705       1490   \n",
       "...           ...   ...         ...       ...        ...       ...        ...   \n",
       "6922   BYD6481ST2   比亚迪   1610,1630      2730       4835      1855       1720   \n",
       "6930    BYD6450V2   比亚迪        1400      2725       4460      1720       1850   \n",
       "6936    BYD6450V3   比亚迪        1400      2725       4460      1720       1850   \n",
       "6938   BYD6481ST8   比亚迪   1730,1750      2730       4835      1855       1720   \n",
       "6955   BYD6481ST6   比亚迪   1730,1750      2730       4835      1855       1720   \n",
       "6964   BYD6480M5F   比亚迪        1790      2960       4820      1810       1765   \n",
       "6993  BYD6481ST6D   比亚迪   1730,1750      2730       4835      1855       1720   \n",
       "6994   BYD6481S9D   比亚迪   1695,1715      2730       4835      1855       1720   \n",
       "7199   BYD6480S5M   比亚迪   1620,1640      2720       4810      1855  1725,1680   \n",
       "7200   BYD6480M5M   比亚迪        1765      2960       4820      1810       1765   \n",
       "7213  BYD6480ST2M   比亚迪   1610,1630      2720       4810      1855  1725,1680   \n",
       "7214   BYD6480M5F   比亚迪        1790      2960       4820      1810       1765   \n",
       "7222  BYD6481ST3M   比亚迪   1610,1630      2730       4835      1855       1720   \n",
       "7223   BYD6480S6M   比亚迪   1665,1685      2720       4810      1855  1725,1680   \n",
       "7247   BYD6480M5A   比亚迪        1790      2960       4820      1810       1765   \n",
       "7297   BYD6480S2D   比亚迪   1695,1715      2720       4810      1855  1725,1680   \n",
       "7510    BYD6481ST   比亚迪        1730      2730       4835      1855       1720   \n",
       "7511   BYD6481ST8   比亚迪   1730,1750      2730       4835      1855       1720   \n",
       "7614   BYD6481ST6   比亚迪   1730,1750      2730       4835      1855       1720   \n",
       "7807   BYD6481ST5   比亚迪   1810,1830      2730       4835      1855       1720   \n",
       "7856   BYD6481ST3   比亚迪   1610,1630      2730       4835      1855       1720   \n",
       "8072    BYD6481ST   比亚迪        1730      2730       4835      1855       1720   \n",
       "8076    BYD6450V3   比亚迪        1400      2725       4460      1720       1850   \n",
       "8113   BYD6481ST2   比亚迪   1610,1630      2730       4835      1855       1720   \n",
       "8134   BYD6481ST8   比亚迪   1730,1750      2730       4835      1855       1720   \n",
       "8201    BYD6450V2   比亚迪        1400      2725       4460      1720       1850   \n",
       "8219   BYD6481ST5   比亚迪   1810,1830      2730       4835      1855       1720   \n",
       "8260    BYD6450V1   比亚迪        1300      2725       4460      1720       1850   \n",
       "8690   BYD6481ST3   比亚迪        1610      2730       4835      1855       1720   \n",
       "8708   BYD6481ST2   比亚迪        1610      2730       4835      1855       1720   \n",
       "\n",
       "     Displacement power                                                vin  \\\n",
       "25           1497    80  LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...   \n",
       "54           1497    80  LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...   \n",
       "88           1497    80                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "90           1497   113                LC0CG4DF×××××××××,LC0CG4CF×××××××××   \n",
       "106          1497    80                LGXC16DF×××××××××,LGXC16CF×××××××××   \n",
       "137          1497    80                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "139          1497   113                LGXC16DF×××××××××,LGXC16CF×××××××××   \n",
       "145          1497   113                LGXC36DF×××××××××,LGXC36CF×××××××××   \n",
       "155          1497    80                LC0CG4DF×××××××××,LC0CG4CF×××××××××   \n",
       "594          1497    80                LGXC16DF×××××××××,LGXC16CF×××××××××   \n",
       "688          1497    80                LGXC16DF×××××××××,LGXC16CF×××××××××   \n",
       "696          1497   113                LGXCG6DF×××××××××,LGXCG6CF×××××××××   \n",
       "698          1497    80                LGXCG6DF×××××××××,LGXCG6CF×××××××××   \n",
       "699          1497    80                LGXCG6DF×××××××××,LGXCG6CF×××××××××   \n",
       "700          1497    80                                  LGXCG6DF×××××××××   \n",
       "701          1497    80                LGXC16DF×××××××××,LGXC16AF×××××××××   \n",
       "702          1497    80                LGXC16DF×××××××××,LGXC16CF×××××××××   \n",
       "703          1497    80  LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...   \n",
       "704          1497    80  LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...   \n",
       "705          1497    80                LGXCG6DF×××××××××,LGXCG6CF×××××××××   \n",
       "720          1497    80  LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...   \n",
       "721          1497    80  LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...   \n",
       "722          1497    80                LGXC16DF×××××××××,LGXC16AF×××××××××   \n",
       "724          1497    80                LGXCG6DF×××××××××,LGXCG6AF×××××××××   \n",
       "725          1497    80                                  LGXCG6DF×××××××××   \n",
       "726          1497    80                LGXC16DF×××××××××,LGXC16CF×××××××××   \n",
       "735          1497    80                LGXC16DF×××××××××,LGXC16AF×××××××××   \n",
       "737          1497    80                LGXCG6DF×××××××××,LGXCG6AF×××××××××   \n",
       "740          1497   113                LGXC16DF×××××××××,LGXC16CF×××××××××   \n",
       "747          1497    80                LGXC16DF×××××××××,LGXC16AF×××××××××   \n",
       "...           ...   ...                                                ...   \n",
       "6922         1497   113                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "6930         1991   103                                  LC0C14DG×××××××××   \n",
       "6936         1991   103                                  LC0C14DG×××××××××   \n",
       "6938         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "6955         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "6964         2362   123                LC0CG4DG×××××××××,LC0CG4CG×××××××××   \n",
       "6993         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "6994         2362   123                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "7199         1991   103  LC0C14AG×××××××××,LC0C14DG×××××××××,LC0C14CG××...   \n",
       "7200         1991   103  LC0CG4DG×××××××××,LC0CG4CG×××××××××,LC0CG4AG××...   \n",
       "7213         1497   113  LC0C14AF×××××××××,LC0C14DF×××××××××,LC0C14CF××...   \n",
       "7214         2362   123                LC0CG4DG×××××××××,LC0CG4CG×××××××××   \n",
       "7222         1497   113                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "7223         2362   123  LC0C14AG×××××××××,LC0C14DG×××××××××,LC0C14CG××...   \n",
       "7247         2362   123                LC0CG4DG×××××××××,LC0CG4CG×××××××××   \n",
       "7297         2362   123  LC0CG4AG×××××××××,LC0CG4CG×××××××××,LC0CG4DG××...   \n",
       "7510         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "7511         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "7614         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "7807         1999   151                                  LC0C64CG×××××××××   \n",
       "7856         1497   113                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "8072         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "8076         1991   103                                  LC0C14DG×××××××××   \n",
       "8113         1497   113                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "8134         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "8201         1991   103                                  LC0C14DG×××××××××   \n",
       "8219         1999   151                                  LC0C64CG×××××××××   \n",
       "8260         1497    80                LC0C14DF×××××××××,LC0C14AF×××××××××   \n",
       "8690         1497   113                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "8708         1497   113                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "\n",
       "      car_factory    3  \n",
       "25      比亚迪汽车有限公司  LGX  \n",
       "54      比亚迪汽车有限公司  LGX  \n",
       "88    比亚迪汽车工业有限公司  LC0  \n",
       "90    比亚迪汽车工业有限公司  LC0  \n",
       "106     比亚迪汽车有限公司  LGX  \n",
       "137   比亚迪汽车工业有限公司  LC0  \n",
       "139     比亚迪汽车有限公司  LGX  \n",
       "145     比亚迪汽车有限公司  LGX  \n",
       "155   比亚迪汽车工业有限公司  LC0  \n",
       "594     比亚迪汽车有限公司  LGX  \n",
       "688     比亚迪汽车有限公司  LGX  \n",
       "696     比亚迪汽车有限公司  LGX  \n",
       "698     比亚迪汽车有限公司  LGX  \n",
       "699     比亚迪汽车有限公司  LGX  \n",
       "700     比亚迪汽车有限公司  LGX  \n",
       "701     比亚迪汽车有限公司  LGX  \n",
       "702     比亚迪汽车有限公司  LGX  \n",
       "703     比亚迪汽车有限公司  LGX  \n",
       "704     比亚迪汽车有限公司  LGX  \n",
       "705     比亚迪汽车有限公司  LGX  \n",
       "720     比亚迪汽车有限公司  LGX  \n",
       "721     比亚迪汽车有限公司  LGX  \n",
       "722     比亚迪汽车有限公司  LGX  \n",
       "724     比亚迪汽车有限公司  LGX  \n",
       "725     比亚迪汽车有限公司  LGX  \n",
       "726     比亚迪汽车有限公司  LGX  \n",
       "735     比亚迪汽车有限公司  LGX  \n",
       "737     比亚迪汽车有限公司  LGX  \n",
       "740     比亚迪汽车有限公司  LGX  \n",
       "747     比亚迪汽车有限公司  LGX  \n",
       "...           ...  ...  \n",
       "6922  比亚迪汽车工业有限公司  LC0  \n",
       "6930  比亚迪汽车工业有限公司  LC0  \n",
       "6936  比亚迪汽车工业有限公司  LC0  \n",
       "6938  比亚迪汽车工业有限公司  LC0  \n",
       "6955  比亚迪汽车工业有限公司  LC0  \n",
       "6964  比亚迪汽车工业有限公司  LC0  \n",
       "6993  比亚迪汽车工业有限公司  LC0  \n",
       "6994  比亚迪汽车工业有限公司  LC0  \n",
       "7199  比亚迪汽车工业有限公司  LC0  \n",
       "7200  比亚迪汽车工业有限公司  LC0  \n",
       "7213  比亚迪汽车工业有限公司  LC0  \n",
       "7214  比亚迪汽车工业有限公司  LC0  \n",
       "7222  比亚迪汽车工业有限公司  LC0  \n",
       "7223  比亚迪汽车工业有限公司  LC0  \n",
       "7247  比亚迪汽车工业有限公司  LC0  \n",
       "7297  比亚迪汽车工业有限公司  LC0  \n",
       "7510  比亚迪汽车工业有限公司  LC0  \n",
       "7511  比亚迪汽车工业有限公司  LC0  \n",
       "7614  比亚迪汽车工业有限公司  LC0  \n",
       "7807  比亚迪汽车工业有限公司  LC0  \n",
       "7856  比亚迪汽车工业有限公司  LC0  \n",
       "8072  比亚迪汽车工业有限公司  LC0  \n",
       "8076  比亚迪汽车工业有限公司  LC0  \n",
       "8113  比亚迪汽车工业有限公司  LC0  \n",
       "8134  比亚迪汽车工业有限公司  LC0  \n",
       "8201  比亚迪汽车工业有限公司  LC0  \n",
       "8219  比亚迪汽车工业有限公司  LC0  \n",
       "8260  比亚迪汽车工业有限公司  LC0  \n",
       "8690  比亚迪汽车工业有限公司  LC0  \n",
       "8708  比亚迪汽车工业有限公司  LC0  \n",
       "\n",
       "[843 rows x 12 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all1[(all1['3']=='LC0')|(all1['3']=='LGX')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>BYD7157A5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>BYD7157A5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>BYD7150S5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1325</td>\n",
       "      <td>2535</td>\n",
       "      <td>4360,4100</td>\n",
       "      <td>1785</td>\n",
       "      <td>1650</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>BYD7150ST5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1430</td>\n",
       "      <td>2535</td>\n",
       "      <td>4360,4100</td>\n",
       "      <td>1785</td>\n",
       "      <td>1650</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0CG4DF×××××××××,LC0CG4CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>BYD7152W</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1270</td>\n",
       "      <td>2718</td>\n",
       "      <td>4765</td>\n",
       "      <td>1837</td>\n",
       "      <td>1500</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>BYD7150S5M1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1325</td>\n",
       "      <td>2535</td>\n",
       "      <td>4360,4100</td>\n",
       "      <td>1785</td>\n",
       "      <td>1650</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>BYD7152WT1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1335</td>\n",
       "      <td>2718</td>\n",
       "      <td>4765</td>\n",
       "      <td>1837</td>\n",
       "      <td>1500</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>BYD7152WT2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1380</td>\n",
       "      <td>2718</td>\n",
       "      <td>4765</td>\n",
       "      <td>1837</td>\n",
       "      <td>1500</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXC36DF×××××××××,LGXC36CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>BYD7150S5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1345</td>\n",
       "      <td>2535</td>\n",
       "      <td>4360,4100</td>\n",
       "      <td>1785</td>\n",
       "      <td>1650</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LC0CG4DF×××××××××,LC0CG4CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td>BYD7150W5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1330</td>\n",
       "      <td>2660</td>\n",
       "      <td>4680</td>\n",
       "      <td>1765</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>BYD7150W5M1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1330</td>\n",
       "      <td>2660</td>\n",
       "      <td>4680</td>\n",
       "      <td>1765</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696</th>\n",
       "      <td>BYD7151WT4</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1395</td>\n",
       "      <td>2670</td>\n",
       "      <td>4700</td>\n",
       "      <td>1790</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>698</th>\n",
       "      <td>BYD7150W9</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1370</td>\n",
       "      <td>2660</td>\n",
       "      <td>4680</td>\n",
       "      <td>1765</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699</th>\n",
       "      <td>BYD7151W3</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1370</td>\n",
       "      <td>2670</td>\n",
       "      <td>4700</td>\n",
       "      <td>1790</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td>BYD7156A5D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4605</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>701</th>\n",
       "      <td>QCJ7150A11</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4533</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>702</th>\n",
       "      <td>BYD7150W8</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1330</td>\n",
       "      <td>2660</td>\n",
       "      <td>4680</td>\n",
       "      <td>1765</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>703</th>\n",
       "      <td>BYD7157A5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>704</th>\n",
       "      <td>BYD7157A5M2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>705</th>\n",
       "      <td>BYD7151W5D1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1370</td>\n",
       "      <td>2670</td>\n",
       "      <td>4700</td>\n",
       "      <td>1790</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>BYD7157A5M1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4617</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>721</th>\n",
       "      <td>BYD7153A5M1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4568</td>\n",
       "      <td>1716</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>722</th>\n",
       "      <td>BYD7150A5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4533</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>724</th>\n",
       "      <td>BYD7156A5D2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4605</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>725</th>\n",
       "      <td>BYD7156A2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4605</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>726</th>\n",
       "      <td>BYD7151W5M1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1330</td>\n",
       "      <td>2670</td>\n",
       "      <td>4700</td>\n",
       "      <td>1790</td>\n",
       "      <td>1480</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>735</th>\n",
       "      <td>BYD7156A1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4605</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>737</th>\n",
       "      <td>BYD7150A5D1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4533</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXCG6DF×××××××××,LGXCG6AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>740</th>\n",
       "      <td>BYD7150WT5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1385</td>\n",
       "      <td>2660</td>\n",
       "      <td>4680</td>\n",
       "      <td>1765</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16CF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>747</th>\n",
       "      <td>BYD7156A5M2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2600</td>\n",
       "      <td>4605</td>\n",
       "      <td>1705</td>\n",
       "      <td>1490</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LGXC16DF×××××××××,LGXC16AF×××××××××</td>\n",
       "      <td>比亚迪汽车有限公司</td>\n",
       "      <td>LGX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6922</th>\n",
       "      <td>BYD6481ST2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1610,1630</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6930</th>\n",
       "      <td>BYD6450V2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1400</td>\n",
       "      <td>2725</td>\n",
       "      <td>4460</td>\n",
       "      <td>1720</td>\n",
       "      <td>1850</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0C14DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6936</th>\n",
       "      <td>BYD6450V3</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1400</td>\n",
       "      <td>2725</td>\n",
       "      <td>4460</td>\n",
       "      <td>1720</td>\n",
       "      <td>1850</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0C14DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6938</th>\n",
       "      <td>BYD6481ST8</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730,1750</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6955</th>\n",
       "      <td>BYD6481ST6</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730,1750</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6964</th>\n",
       "      <td>BYD6480M5F</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1790</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4DG×××××××××,LC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6993</th>\n",
       "      <td>BYD6481ST6D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730,1750</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6994</th>\n",
       "      <td>BYD6481S9D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1695,1715</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7199</th>\n",
       "      <td>BYD6480S5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1620,1640</td>\n",
       "      <td>2720</td>\n",
       "      <td>4810</td>\n",
       "      <td>1855</td>\n",
       "      <td>1725,1680</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0C14AG×××××××××,LC0C14DG×××××××××,LC0C14CG××...</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7200</th>\n",
       "      <td>BYD6480M5M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1765</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0CG4DG×××××××××,LC0CG4CG×××××××××,LC0CG4AG××...</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7213</th>\n",
       "      <td>BYD6480ST2M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1610,1630</td>\n",
       "      <td>2720</td>\n",
       "      <td>4810</td>\n",
       "      <td>1855</td>\n",
       "      <td>1725,1680</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0C14AF×××××××××,LC0C14DF×××××××××,LC0C14CF××...</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7214</th>\n",
       "      <td>BYD6480M5F</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1790</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4DG×××××××××,LC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7222</th>\n",
       "      <td>BYD6481ST3M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1610,1630</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7223</th>\n",
       "      <td>BYD6480S6M</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1665,1685</td>\n",
       "      <td>2720</td>\n",
       "      <td>4810</td>\n",
       "      <td>1855</td>\n",
       "      <td>1725,1680</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0C14AG×××××××××,LC0C14DG×××××××××,LC0C14CG××...</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7247</th>\n",
       "      <td>BYD6480M5A</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1790</td>\n",
       "      <td>2960</td>\n",
       "      <td>4820</td>\n",
       "      <td>1810</td>\n",
       "      <td>1765</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4DG×××××××××,LC0CG4CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7297</th>\n",
       "      <td>BYD6480S2D</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1695,1715</td>\n",
       "      <td>2720</td>\n",
       "      <td>4810</td>\n",
       "      <td>1855</td>\n",
       "      <td>1725,1680</td>\n",
       "      <td>2362</td>\n",
       "      <td>123</td>\n",
       "      <td>LC0CG4AG×××××××××,LC0CG4CG×××××××××,LC0CG4DG××...</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7510</th>\n",
       "      <td>BYD6481ST</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7511</th>\n",
       "      <td>BYD6481ST8</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730,1750</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7614</th>\n",
       "      <td>BYD6481ST6</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730,1750</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7807</th>\n",
       "      <td>BYD6481ST5</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1810,1830</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0C64CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7856</th>\n",
       "      <td>BYD6481ST3</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1610,1630</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8072</th>\n",
       "      <td>BYD6481ST</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8076</th>\n",
       "      <td>BYD6450V3</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1400</td>\n",
       "      <td>2725</td>\n",
       "      <td>4460</td>\n",
       "      <td>1720</td>\n",
       "      <td>1850</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0C14DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8113</th>\n",
       "      <td>BYD6481ST2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1610,1630</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8134</th>\n",
       "      <td>BYD6481ST8</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1730,1750</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0CG4CG×××××××××,LC0CG4DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8201</th>\n",
       "      <td>BYD6450V2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1400</td>\n",
       "      <td>2725</td>\n",
       "      <td>4460</td>\n",
       "      <td>1720</td>\n",
       "      <td>1850</td>\n",
       "      <td>1991</td>\n",
       "      <td>103</td>\n",
       "      <td>LC0C14DG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8219</th>\n",
       "      <td>BYD6481ST5</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1810,1830</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1999</td>\n",
       "      <td>151</td>\n",
       "      <td>LC0C64CG×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8260</th>\n",
       "      <td>BYD6450V1</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1300</td>\n",
       "      <td>2725</td>\n",
       "      <td>4460</td>\n",
       "      <td>1720</td>\n",
       "      <td>1850</td>\n",
       "      <td>1497</td>\n",
       "      <td>80</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14AF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8690</th>\n",
       "      <td>BYD6481ST3</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1610</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8708</th>\n",
       "      <td>BYD6481ST2</td>\n",
       "      <td>比亚迪</td>\n",
       "      <td>1610</td>\n",
       "      <td>2730</td>\n",
       "      <td>4835</td>\n",
       "      <td>1855</td>\n",
       "      <td>1720</td>\n",
       "      <td>1497</td>\n",
       "      <td>113</td>\n",
       "      <td>LC0C14DF×××××××××,LC0C14CF×××××××××</td>\n",
       "      <td>比亚迪汽车工业有限公司</td>\n",
       "      <td>LC0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>843 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      notice_type brand curb_weight Wheelbase car_length car_width car_height  \\\n",
       "25     BYD7157A5M   比亚迪        1210      2615       4617      1716       1480   \n",
       "54     BYD7157A5D   比亚迪        1210      2615       4617      1716       1480   \n",
       "88     BYD7150S5M   比亚迪        1325      2535  4360,4100      1785       1650   \n",
       "90    BYD7150ST5D   比亚迪        1430      2535  4360,4100      1785       1650   \n",
       "106      BYD7152W   比亚迪        1270      2718       4765      1837       1500   \n",
       "137   BYD7150S5M1   比亚迪        1325      2535  4360,4100      1785       1650   \n",
       "139    BYD7152WT1   比亚迪        1335      2718       4765      1837       1500   \n",
       "145    BYD7152WT2   比亚迪        1380      2718       4765      1837       1500   \n",
       "155    BYD7150S5D   比亚迪        1345      2535  4360,4100      1785       1650   \n",
       "594    BYD7150W5M   比亚迪        1330      2660       4680      1765       1490   \n",
       "688   BYD7150W5M1   比亚迪        1330      2660       4680      1765       1490   \n",
       "696    BYD7151WT4   比亚迪        1395      2670       4700      1790       1480   \n",
       "698     BYD7150W9   比亚迪        1370      2660       4680      1765       1490   \n",
       "699     BYD7151W3   比亚迪        1370      2670       4700      1790       1480   \n",
       "700    BYD7156A5D   比亚迪        1210      2600       4605      1705       1490   \n",
       "701    QCJ7150A11   比亚迪        1210      2600       4533      1705       1490   \n",
       "702     BYD7150W8   比亚迪        1330      2660       4680      1765       1490   \n",
       "703    BYD7157A5M   比亚迪        1210      2615       4617      1716       1480   \n",
       "704   BYD7157A5M2   比亚迪        1210      2615       4617      1716       1480   \n",
       "705   BYD7151W5D1   比亚迪        1370      2670       4700      1790       1480   \n",
       "720   BYD7157A5M1   比亚迪        1210      2615       4617      1716       1480   \n",
       "721   BYD7153A5M1   比亚迪        1210      2615       4568      1716       1480   \n",
       "722    BYD7150A5M   比亚迪        1210      2600       4533      1705       1490   \n",
       "724   BYD7156A5D2   比亚迪        1210      2600       4605      1705       1490   \n",
       "725     BYD7156A2   比亚迪        1210      2600       4605      1705       1490   \n",
       "726   BYD7151W5M1   比亚迪        1330      2670       4700      1790       1480   \n",
       "735     BYD7156A1   比亚迪        1210      2600       4605      1705       1490   \n",
       "737   BYD7150A5D1   比亚迪        1210      2600       4533      1705       1490   \n",
       "740   BYD7150WT5M   比亚迪        1385      2660       4680      1765       1490   \n",
       "747   BYD7156A5M2   比亚迪        1210      2600       4605      1705       1490   \n",
       "...           ...   ...         ...       ...        ...       ...        ...   \n",
       "6922   BYD6481ST2   比亚迪   1610,1630      2730       4835      1855       1720   \n",
       "6930    BYD6450V2   比亚迪        1400      2725       4460      1720       1850   \n",
       "6936    BYD6450V3   比亚迪        1400      2725       4460      1720       1850   \n",
       "6938   BYD6481ST8   比亚迪   1730,1750      2730       4835      1855       1720   \n",
       "6955   BYD6481ST6   比亚迪   1730,1750      2730       4835      1855       1720   \n",
       "6964   BYD6480M5F   比亚迪        1790      2960       4820      1810       1765   \n",
       "6993  BYD6481ST6D   比亚迪   1730,1750      2730       4835      1855       1720   \n",
       "6994   BYD6481S9D   比亚迪   1695,1715      2730       4835      1855       1720   \n",
       "7199   BYD6480S5M   比亚迪   1620,1640      2720       4810      1855  1725,1680   \n",
       "7200   BYD6480M5M   比亚迪        1765      2960       4820      1810       1765   \n",
       "7213  BYD6480ST2M   比亚迪   1610,1630      2720       4810      1855  1725,1680   \n",
       "7214   BYD6480M5F   比亚迪        1790      2960       4820      1810       1765   \n",
       "7222  BYD6481ST3M   比亚迪   1610,1630      2730       4835      1855       1720   \n",
       "7223   BYD6480S6M   比亚迪   1665,1685      2720       4810      1855  1725,1680   \n",
       "7247   BYD6480M5A   比亚迪        1790      2960       4820      1810       1765   \n",
       "7297   BYD6480S2D   比亚迪   1695,1715      2720       4810      1855  1725,1680   \n",
       "7510    BYD6481ST   比亚迪        1730      2730       4835      1855       1720   \n",
       "7511   BYD6481ST8   比亚迪   1730,1750      2730       4835      1855       1720   \n",
       "7614   BYD6481ST6   比亚迪   1730,1750      2730       4835      1855       1720   \n",
       "7807   BYD6481ST5   比亚迪   1810,1830      2730       4835      1855       1720   \n",
       "7856   BYD6481ST3   比亚迪   1610,1630      2730       4835      1855       1720   \n",
       "8072    BYD6481ST   比亚迪        1730      2730       4835      1855       1720   \n",
       "8076    BYD6450V3   比亚迪        1400      2725       4460      1720       1850   \n",
       "8113   BYD6481ST2   比亚迪   1610,1630      2730       4835      1855       1720   \n",
       "8134   BYD6481ST8   比亚迪   1730,1750      2730       4835      1855       1720   \n",
       "8201    BYD6450V2   比亚迪        1400      2725       4460      1720       1850   \n",
       "8219   BYD6481ST5   比亚迪   1810,1830      2730       4835      1855       1720   \n",
       "8260    BYD6450V1   比亚迪        1300      2725       4460      1720       1850   \n",
       "8690   BYD6481ST3   比亚迪        1610      2730       4835      1855       1720   \n",
       "8708   BYD6481ST2   比亚迪        1610      2730       4835      1855       1720   \n",
       "\n",
       "     Displacement power                                                vin  \\\n",
       "25           1497    80  LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...   \n",
       "54           1497    80  LGXCG6DF×××××××××,LGXCG6AF×××××××××,LGXCG6CF××...   \n",
       "88           1497    80                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "90           1497   113                LC0CG4DF×××××××××,LC0CG4CF×××××××××   \n",
       "106          1497    80                LGXC16DF×××××××××,LGXC16CF×××××××××   \n",
       "137          1497    80                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "139          1497   113                LGXC16DF×××××××××,LGXC16CF×××××××××   \n",
       "145          1497   113                LGXC36DF×××××××××,LGXC36CF×××××××××   \n",
       "155          1497    80                LC0CG4DF×××××××××,LC0CG4CF×××××××××   \n",
       "594          1497    80                LGXC16DF×××××××××,LGXC16CF×××××××××   \n",
       "688          1497    80                LGXC16DF×××××××××,LGXC16CF×××××××××   \n",
       "696          1497   113                LGXCG6DF×××××××××,LGXCG6CF×××××××××   \n",
       "698          1497    80                LGXCG6DF×××××××××,LGXCG6CF×××××××××   \n",
       "699          1497    80                LGXCG6DF×××××××××,LGXCG6CF×××××××××   \n",
       "700          1497    80                                  LGXCG6DF×××××××××   \n",
       "701          1497    80                LGXC16DF×××××××××,LGXC16AF×××××××××   \n",
       "702          1497    80                LGXC16DF×××××××××,LGXC16CF×××××××××   \n",
       "703          1497    80  LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...   \n",
       "704          1497    80  LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...   \n",
       "705          1497    80                LGXCG6DF×××××××××,LGXCG6CF×××××××××   \n",
       "720          1497    80  LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...   \n",
       "721          1497    80  LGXC16DF×××××××××,LGXC16AF×××××××××,LGXC16CF××...   \n",
       "722          1497    80                LGXC16DF×××××××××,LGXC16AF×××××××××   \n",
       "724          1497    80                LGXCG6DF×××××××××,LGXCG6AF×××××××××   \n",
       "725          1497    80                                  LGXCG6DF×××××××××   \n",
       "726          1497    80                LGXC16DF×××××××××,LGXC16CF×××××××××   \n",
       "735          1497    80                LGXC16DF×××××××××,LGXC16AF×××××××××   \n",
       "737          1497    80                LGXCG6DF×××××××××,LGXCG6AF×××××××××   \n",
       "740          1497   113                LGXC16DF×××××××××,LGXC16CF×××××××××   \n",
       "747          1497    80                LGXC16DF×××××××××,LGXC16AF×××××××××   \n",
       "...           ...   ...                                                ...   \n",
       "6922         1497   113                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "6930         1991   103                                  LC0C14DG×××××××××   \n",
       "6936         1991   103                                  LC0C14DG×××××××××   \n",
       "6938         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "6955         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "6964         2362   123                LC0CG4DG×××××××××,LC0CG4CG×××××××××   \n",
       "6993         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "6994         2362   123                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "7199         1991   103  LC0C14AG×××××××××,LC0C14DG×××××××××,LC0C14CG××...   \n",
       "7200         1991   103  LC0CG4DG×××××××××,LC0CG4CG×××××××××,LC0CG4AG××...   \n",
       "7213         1497   113  LC0C14AF×××××××××,LC0C14DF×××××××××,LC0C14CF××...   \n",
       "7214         2362   123                LC0CG4DG×××××××××,LC0CG4CG×××××××××   \n",
       "7222         1497   113                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "7223         2362   123  LC0C14AG×××××××××,LC0C14DG×××××××××,LC0C14CG××...   \n",
       "7247         2362   123                LC0CG4DG×××××××××,LC0CG4CG×××××××××   \n",
       "7297         2362   123  LC0CG4AG×××××××××,LC0CG4CG×××××××××,LC0CG4DG××...   \n",
       "7510         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "7511         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "7614         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "7807         1999   151                                  LC0C64CG×××××××××   \n",
       "7856         1497   113                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "8072         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "8076         1991   103                                  LC0C14DG×××××××××   \n",
       "8113         1497   113                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "8134         1999   151                LC0CG4CG×××××××××,LC0CG4DG×××××××××   \n",
       "8201         1991   103                                  LC0C14DG×××××××××   \n",
       "8219         1999   151                                  LC0C64CG×××××××××   \n",
       "8260         1497    80                LC0C14DF×××××××××,LC0C14AF×××××××××   \n",
       "8690         1497   113                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "8708         1497   113                LC0C14DF×××××××××,LC0C14CF×××××××××   \n",
       "\n",
       "      car_factory    3  \n",
       "25      比亚迪汽车有限公司  LGX  \n",
       "54      比亚迪汽车有限公司  LGX  \n",
       "88    比亚迪汽车工业有限公司  LC0  \n",
       "90    比亚迪汽车工业有限公司  LC0  \n",
       "106     比亚迪汽车有限公司  LGX  \n",
       "137   比亚迪汽车工业有限公司  LC0  \n",
       "139     比亚迪汽车有限公司  LGX  \n",
       "145     比亚迪汽车有限公司  LGX  \n",
       "155   比亚迪汽车工业有限公司  LC0  \n",
       "594     比亚迪汽车有限公司  LGX  \n",
       "688     比亚迪汽车有限公司  LGX  \n",
       "696     比亚迪汽车有限公司  LGX  \n",
       "698     比亚迪汽车有限公司  LGX  \n",
       "699     比亚迪汽车有限公司  LGX  \n",
       "700     比亚迪汽车有限公司  LGX  \n",
       "701     比亚迪汽车有限公司  LGX  \n",
       "702     比亚迪汽车有限公司  LGX  \n",
       "703     比亚迪汽车有限公司  LGX  \n",
       "704     比亚迪汽车有限公司  LGX  \n",
       "705     比亚迪汽车有限公司  LGX  \n",
       "720     比亚迪汽车有限公司  LGX  \n",
       "721     比亚迪汽车有限公司  LGX  \n",
       "722     比亚迪汽车有限公司  LGX  \n",
       "724     比亚迪汽车有限公司  LGX  \n",
       "725     比亚迪汽车有限公司  LGX  \n",
       "726     比亚迪汽车有限公司  LGX  \n",
       "735     比亚迪汽车有限公司  LGX  \n",
       "737     比亚迪汽车有限公司  LGX  \n",
       "740     比亚迪汽车有限公司  LGX  \n",
       "747     比亚迪汽车有限公司  LGX  \n",
       "...           ...  ...  \n",
       "6922  比亚迪汽车工业有限公司  LC0  \n",
       "6930  比亚迪汽车工业有限公司  LC0  \n",
       "6936  比亚迪汽车工业有限公司  LC0  \n",
       "6938  比亚迪汽车工业有限公司  LC0  \n",
       "6955  比亚迪汽车工业有限公司  LC0  \n",
       "6964  比亚迪汽车工业有限公司  LC0  \n",
       "6993  比亚迪汽车工业有限公司  LC0  \n",
       "6994  比亚迪汽车工业有限公司  LC0  \n",
       "7199  比亚迪汽车工业有限公司  LC0  \n",
       "7200  比亚迪汽车工业有限公司  LC0  \n",
       "7213  比亚迪汽车工业有限公司  LC0  \n",
       "7214  比亚迪汽车工业有限公司  LC0  \n",
       "7222  比亚迪汽车工业有限公司  LC0  \n",
       "7223  比亚迪汽车工业有限公司  LC0  \n",
       "7247  比亚迪汽车工业有限公司  LC0  \n",
       "7297  比亚迪汽车工业有限公司  LC0  \n",
       "7510  比亚迪汽车工业有限公司  LC0  \n",
       "7511  比亚迪汽车工业有限公司  LC0  \n",
       "7614  比亚迪汽车工业有限公司  LC0  \n",
       "7807  比亚迪汽车工业有限公司  LC0  \n",
       "7856  比亚迪汽车工业有限公司  LC0  \n",
       "8072  比亚迪汽车工业有限公司  LC0  \n",
       "8076  比亚迪汽车工业有限公司  LC0  \n",
       "8113  比亚迪汽车工业有限公司  LC0  \n",
       "8134  比亚迪汽车工业有限公司  LC0  \n",
       "8201  比亚迪汽车工业有限公司  LC0  \n",
       "8219  比亚迪汽车工业有限公司  LC0  \n",
       "8260  比亚迪汽车工业有限公司  LC0  \n",
       "8690  比亚迪汽车工业有限公司  LC0  \n",
       "8708  比亚迪汽车工业有限公司  LC0  \n",
       "\n",
       "[843 rows x 12 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all1[(all1['brand']=='比亚迪')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
